{
    "statement": "(\n    select\n        `activity`.`id`,\n        `activity`.`opporid`,\n        `activity`.`category`,\n        `details`.`name`,\n        `details`.`company`,\n        `activity`.`alertpic`,\n        `activity`.`datetime` as `start`,\n        `activity`.`end_datetime` as `end`,\n        `activity`.`notes` as `description`,\n        `status`.`color`,\n        `status`.`id` as `status_id`,\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) as `is_long`\n    from\n        `activity`\n        left join `opportunities` on `opportunities`.`id` = `activity`.`opporid`\n        left join `details` on `details`.`id` = `opportunities`.`customer_id`\n        left join `status` on `status`.`id` = `activity`.`status`\n        right join (\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    uses_permissions AS U1\n                    LEFT JOIN activity as A1 ON (A1.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (1200)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A1.parentid = 6\n                    AND A1.isactive = 1\n                    AND (\n                        A1.datetime <= '2022-12-19 23:59:59'\n                        AND A1.end_datetime >= '2022-12-19 00:00:00'\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    global_permissions AS U1\n                    LEFT JOIN activity AS A2 ON (A2.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (11980)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A2.parentid = 6\n                    AND A2.isactive = 1\n                    AND (\n                        A2.datetime <= '2022-12-19 23:59:59'\n                        AND A2.end_datetime >= '2022-12-19 00:00:00'\n                    )\n            )\n        ) as `subaup` on `subaup`.`ref_id` = `activity`.`id`\n        right join (\n            (\n                SELECT\n                    DISTINCT main_sql.ref_id\n                FROM\n                    uses_permissions as main_sql\n                    INNER JOIN uses_permissions AS P2 ON main_sql.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity as A1 ON (A1.id = main_sql.ref_id)\n                WHERE\n                    main_sql.parentid = 6\n                    AND main_sql.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-19 23:59:59'\n                        AND A1.end_datetime >= '2022-12-19 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql.type = 'activity'\n                            AND main_sql.current_permission != 0\n                            AND main_sql.profileid IN (1200)\n                        )\n                        OR (\n                            main_sql.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'deal'\n                                    AND uses_permissions.ref_id = main_sql.deal_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                        OR (\n                            main_sql.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'customer'\n                                    AND uses_permissions.ref_id = main_sql.customer_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT main_sql_dept.ref_id\n                FROM\n                    global_permissions as main_sql_dept\n                    INNER JOIN uses_permissions AS P2 ON main_sql_dept.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity AS A1 ON (A1.id = main_sql_dept.ref_id)\n                WHERE\n                    main_sql_dept.parentid = 6\n                    AND main_sql_dept.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-19 23:59:59'\n                        AND A1.end_datetime >= '2022-12-19 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql_dept.type = 'activity'\n                            AND main_sql_dept.current_permission != 0\n                            AND main_sql_dept.profileid IN (11980)\n                        )\n                        OR (\n                            main_sql_dept.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'deal'\n                                    AND global_permissions.ref_id = main_sql_dept.deal_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                        OR (\n                            main_sql_dept.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'customer'\n                                    AND global_permissions.ref_id = main_sql_dept.customer_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                    )\n            )\n        ) as `subaccessq` on `subaccessq`.`ref_id` = `activity`.`id`\n    where\n        `activity`.`isactive` = 1\n        and (1 = 1)\n        and `activity`.`parentid` = 6\n    order by\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) DESC,\n        activity.datetime DESC,\n        activity.id DESC\n    limit\n        7 offset 0\n)\nunion\n(\n    select\n        `activity`.`id`,\n        `activity`.`opporid`,\n        `activity`.`category`,\n        `details`.`name`,\n        `details`.`company`,\n        `activity`.`alertpic`,\n        `activity`.`datetime` as `start`,\n        `activity`.`end_datetime` as `end`,\n        `activity`.`notes` as `description`,\n        `status`.`color`,\n        `status`.`id` as `status_id`,\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) as `is_long`\n    from\n        `activity`\n        left join `opportunities` on `opportunities`.`id` = `activity`.`opporid`\n        left join `details` on `details`.`id` = `opportunities`.`customer_id`\n        left join `status` on `status`.`id` = `activity`.`status`\n        right join (\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    uses_permissions AS U1\n                    LEFT JOIN activity as A1 ON (A1.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (1200)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A1.parentid = 6\n                    AND A1.isactive = 1\n                    AND (\n                        A1.datetime <= '2022-12-20 23:59:59'\n                        AND A1.end_datetime >= '2022-12-20 00:00:00'\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    global_permissions AS U1\n                    LEFT JOIN activity AS A2 ON (A2.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (11980)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A2.parentid = 6\n                    AND A2.isactive = 1\n                    AND (\n                        A2.datetime <= '2022-12-20 23:59:59'\n                        AND A2.end_datetime >= '2022-12-20 00:00:00'\n                    )\n            )\n        ) as `subaup` on `subaup`.`ref_id` = `activity`.`id`\n        right join (\n            (\n                SELECT\n                    DISTINCT main_sql.ref_id\n                FROM\n                    uses_permissions as main_sql\n                    INNER JOIN uses_permissions AS P2 ON main_sql.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity as A1 ON (A1.id = main_sql.ref_id)\n                WHERE\n                    main_sql.parentid = 6\n                    AND main_sql.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-20 23:59:59'\n                        AND A1.end_datetime >= '2022-12-20 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql.type = 'activity'\n                            AND main_sql.current_permission != 0\n                            AND main_sql.profileid IN (1200)\n                        )\n                        OR (\n                            main_sql.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'deal'\n                                    AND uses_permissions.ref_id = main_sql.deal_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                        OR (\n                            main_sql.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'customer'\n                                    AND uses_permissions.ref_id = main_sql.customer_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT main_sql_dept.ref_id\n                FROM\n                    global_permissions as main_sql_dept\n                    INNER JOIN uses_permissions AS P2 ON main_sql_dept.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity AS A1 ON (A1.id = main_sql_dept.ref_id)\n                WHERE\n                    main_sql_dept.parentid = 6\n                    AND main_sql_dept.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-20 23:59:59'\n                        AND A1.end_datetime >= '2022-12-20 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql_dept.type = 'activity'\n                            AND main_sql_dept.current_permission != 0\n                            AND main_sql_dept.profileid IN (11980)\n                        )\n                        OR (\n                            main_sql_dept.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'deal'\n                                    AND global_permissions.ref_id = main_sql_dept.deal_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                        OR (\n                            main_sql_dept.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'customer'\n                                    AND global_permissions.ref_id = main_sql_dept.customer_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                    )\n            )\n        ) as `subaccessq` on `subaccessq`.`ref_id` = `activity`.`id`\n    where\n        `activity`.`isactive` = 1\n        and (1 = 1)\n        and `activity`.`parentid` = 6\n    order by\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) DESC,\n        activity.datetime DESC,\n        activity.id DESC\n    limit\n        7 offset 0\n)\nunion\n(\n    select\n        `activity`.`id`,\n        `activity`.`opporid`,\n        `activity`.`category`,\n        `details`.`name`,\n        `details`.`company`,\n        `activity`.`alertpic`,\n        `activity`.`datetime` as `start`,\n        `activity`.`end_datetime` as `end`,\n        `activity`.`notes` as `description`,\n        `status`.`color`,\n        `status`.`id` as `status_id`,\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) as `is_long`\n    from\n        `activity`\n        left join `opportunities` on `opportunities`.`id` = `activity`.`opporid`\n        left join `details` on `details`.`id` = `opportunities`.`customer_id`\n        left join `status` on `status`.`id` = `activity`.`status`\n        right join (\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    uses_permissions AS U1\n                    LEFT JOIN activity as A1 ON (A1.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (1200)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A1.parentid = 6\n                    AND A1.isactive = 1\n                    AND (\n                        A1.datetime <= '2022-12-21 23:59:59'\n                        AND A1.end_datetime >= '2022-12-21 00:00:00'\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    global_permissions AS U1\n                    LEFT JOIN activity AS A2 ON (A2.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (11980)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A2.parentid = 6\n                    AND A2.isactive = 1\n                    AND (\n                        A2.datetime <= '2022-12-21 23:59:59'\n                        AND A2.end_datetime >= '2022-12-21 00:00:00'\n                    )\n            )\n        ) as `subaup` on `subaup`.`ref_id` = `activity`.`id`\n        right join (\n            (\n                SELECT\n                    DISTINCT main_sql.ref_id\n                FROM\n                    uses_permissions as main_sql\n                    INNER JOIN uses_permissions AS P2 ON main_sql.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity as A1 ON (A1.id = main_sql.ref_id)\n                WHERE\n                    main_sql.parentid = 6\n                    AND main_sql.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-21 23:59:59'\n                        AND A1.end_datetime >= '2022-12-21 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql.type = 'activity'\n                            AND main_sql.current_permission != 0\n                            AND main_sql.profileid IN (1200)\n                        )\n                        OR (\n                            main_sql.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'deal'\n                                    AND uses_permissions.ref_id = main_sql.deal_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                        OR (\n                            main_sql.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'customer'\n                                    AND uses_permissions.ref_id = main_sql.customer_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT main_sql_dept.ref_id\n                FROM\n                    global_permissions as main_sql_dept\n                    INNER JOIN uses_permissions AS P2 ON main_sql_dept.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity AS A1 ON (A1.id = main_sql_dept.ref_id)\n                WHERE\n                    main_sql_dept.parentid = 6\n                    AND main_sql_dept.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-21 23:59:59'\n                        AND A1.end_datetime >= '2022-12-21 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql_dept.type = 'activity'\n                            AND main_sql_dept.current_permission != 0\n                            AND main_sql_dept.profileid IN (11980)\n                        )\n                        OR (\n                            main_sql_dept.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'deal'\n                                    AND global_permissions.ref_id = main_sql_dept.deal_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                        OR (\n                            main_sql_dept.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'customer'\n                                    AND global_permissions.ref_id = main_sql_dept.customer_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                    )\n            )\n        ) as `subaccessq` on `subaccessq`.`ref_id` = `activity`.`id`\n    where\n        `activity`.`isactive` = 1\n        and (1 = 1)\n        and `activity`.`parentid` = 6\n    order by\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) DESC,\n        activity.datetime DESC,\n        activity.id DESC\n    limit\n        7 offset 0\n)\nunion\n(\n    select\n        `activity`.`id`,\n        `activity`.`opporid`,\n        `activity`.`category`,\n        `details`.`name`,\n        `details`.`company`,\n        `activity`.`alertpic`,\n        `activity`.`datetime` as `start`,\n        `activity`.`end_datetime` as `end`,\n        `activity`.`notes` as `description`,\n        `status`.`color`,\n        `status`.`id` as `status_id`,\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) as `is_long`\n    from\n        `activity`\n        left join `opportunities` on `opportunities`.`id` = `activity`.`opporid`\n        left join `details` on `details`.`id` = `opportunities`.`customer_id`\n        left join `status` on `status`.`id` = `activity`.`status`\n        right join (\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    uses_permissions AS U1\n                    LEFT JOIN activity as A1 ON (A1.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (1200)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A1.parentid = 6\n                    AND A1.isactive = 1\n                    AND (\n                        A1.datetime <= '2022-12-22 23:59:59'\n                        AND A1.end_datetime >= '2022-12-22 00:00:00'\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    global_permissions AS U1\n                    LEFT JOIN activity AS A2 ON (A2.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (11980)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A2.parentid = 6\n                    AND A2.isactive = 1\n                    AND (\n                        A2.datetime <= '2022-12-22 23:59:59'\n                        AND A2.end_datetime >= '2022-12-22 00:00:00'\n                    )\n            )\n        ) as `subaup` on `subaup`.`ref_id` = `activity`.`id`\n        right join (\n            (\n                SELECT\n                    DISTINCT main_sql.ref_id\n                FROM\n                    uses_permissions as main_sql\n                    INNER JOIN uses_permissions AS P2 ON main_sql.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity as A1 ON (A1.id = main_sql.ref_id)\n                WHERE\n                    main_sql.parentid = 6\n                    AND main_sql.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-22 23:59:59'\n                        AND A1.end_datetime >= '2022-12-22 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql.type = 'activity'\n                            AND main_sql.current_permission != 0\n                            AND main_sql.profileid IN (1200)\n                        )\n                        OR (\n                            main_sql.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'deal'\n                                    AND uses_permissions.ref_id = main_sql.deal_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                        OR (\n                            main_sql.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'customer'\n                                    AND uses_permissions.ref_id = main_sql.customer_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT main_sql_dept.ref_id\n                FROM\n                    global_permissions as main_sql_dept\n                    INNER JOIN uses_permissions AS P2 ON main_sql_dept.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity AS A1 ON (A1.id = main_sql_dept.ref_id)\n                WHERE\n                    main_sql_dept.parentid = 6\n                    AND main_sql_dept.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-22 23:59:59'\n                        AND A1.end_datetime >= '2022-12-22 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql_dept.type = 'activity'\n                            AND main_sql_dept.current_permission != 0\n                            AND main_sql_dept.profileid IN (11980)\n                        )\n                        OR (\n                            main_sql_dept.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'deal'\n                                    AND global_permissions.ref_id = main_sql_dept.deal_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                        OR (\n                            main_sql_dept.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'customer'\n                                    AND global_permissions.ref_id = main_sql_dept.customer_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                    )\n            )\n        ) as `subaccessq` on `subaccessq`.`ref_id` = `activity`.`id`\n    where\n        `activity`.`isactive` = 1\n        and (1 = 1)\n        and `activity`.`parentid` = 6\n    order by\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) DESC,\n        activity.datetime DESC,\n        activity.id DESC\n    limit\n        7 offset 0\n)\nunion\n(\n    select\n        `activity`.`id`,\n        `activity`.`opporid`,\n        `activity`.`category`,\n        `details`.`name`,\n        `details`.`company`,\n        `activity`.`alertpic`,\n        `activity`.`datetime` as `start`,\n        `activity`.`end_datetime` as `end`,\n        `activity`.`notes` as `description`,\n        `status`.`color`,\n        `status`.`id` as `status_id`,\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) as `is_long`\n    from\n        `activity`\n        left join `opportunities` on `opportunities`.`id` = `activity`.`opporid`\n        left join `details` on `details`.`id` = `opportunities`.`customer_id`\n        left join `status` on `status`.`id` = `activity`.`status`\n        right join (\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    uses_permissions AS U1\n                    LEFT JOIN activity as A1 ON (A1.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (1200)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A1.parentid = 6\n                    AND A1.isactive = 1\n                    AND (\n                        A1.datetime <= '2022-12-23 23:59:59'\n                        AND A1.end_datetime >= '2022-12-23 00:00:00'\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    global_permissions AS U1\n                    LEFT JOIN activity AS A2 ON (A2.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (11980)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A2.parentid = 6\n                    AND A2.isactive = 1\n                    AND (\n                        A2.datetime <= '2022-12-23 23:59:59'\n                        AND A2.end_datetime >= '2022-12-23 00:00:00'\n                    )\n            )\n        ) as `subaup` on `subaup`.`ref_id` = `activity`.`id`\n        right join (\n            (\n                SELECT\n                    DISTINCT main_sql.ref_id\n                FROM\n                    uses_permissions as main_sql\n                    INNER JOIN uses_permissions AS P2 ON main_sql.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity as A1 ON (A1.id = main_sql.ref_id)\n                WHERE\n                    main_sql.parentid = 6\n                    AND main_sql.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-23 23:59:59'\n                        AND A1.end_datetime >= '2022-12-23 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql.type = 'activity'\n                            AND main_sql.current_permission != 0\n                            AND main_sql.profileid IN (1200)\n                        )\n                        OR (\n                            main_sql.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'deal'\n                                    AND uses_permissions.ref_id = main_sql.deal_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                        OR (\n                            main_sql.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'customer'\n                                    AND uses_permissions.ref_id = main_sql.customer_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT main_sql_dept.ref_id\n                FROM\n                    global_permissions as main_sql_dept\n                    INNER JOIN uses_permissions AS P2 ON main_sql_dept.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity AS A1 ON (A1.id = main_sql_dept.ref_id)\n                WHERE\n                    main_sql_dept.parentid = 6\n                    AND main_sql_dept.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-23 23:59:59'\n                        AND A1.end_datetime >= '2022-12-23 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql_dept.type = 'activity'\n                            AND main_sql_dept.current_permission != 0\n                            AND main_sql_dept.profileid IN (11980)\n                        )\n                        OR (\n                            main_sql_dept.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'deal'\n                                    AND global_permissions.ref_id = main_sql_dept.deal_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                        OR (\n                            main_sql_dept.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'customer'\n                                    AND global_permissions.ref_id = main_sql_dept.customer_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                    )\n            )\n        ) as `subaccessq` on `subaccessq`.`ref_id` = `activity`.`id`\n    where\n        `activity`.`isactive` = 1\n        and (1 = 1)\n        and `activity`.`parentid` = 6\n    order by\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) DESC,\n        activity.datetime DESC,\n        activity.id DESC\n    limit\n        7 offset 0\n)\nunion\n(\n    select\n        `activity`.`id`,\n        `activity`.`opporid`,\n        `activity`.`category`,\n        `details`.`name`,\n        `details`.`company`,\n        `activity`.`alertpic`,\n        `activity`.`datetime` as `start`,\n        `activity`.`end_datetime` as `end`,\n        `activity`.`notes` as `description`,\n        `status`.`color`,\n        `status`.`id` as `status_id`,\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) as `is_long`\n    from\n        `activity`\n        left join `opportunities` on `opportunities`.`id` = `activity`.`opporid`\n        left join `details` on `details`.`id` = `opportunities`.`customer_id`\n        left join `status` on `status`.`id` = `activity`.`status`\n        right join (\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    uses_permissions AS U1\n                    LEFT JOIN activity as A1 ON (A1.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (1200)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A1.parentid = 6\n                    AND A1.isactive = 1\n                    AND (\n                        A1.datetime <= '2022-12-24 23:59:59'\n                        AND A1.end_datetime >= '2022-12-24 00:00:00'\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    global_permissions AS U1\n                    LEFT JOIN activity AS A2 ON (A2.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (11980)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A2.parentid = 6\n                    AND A2.isactive = 1\n                    AND (\n                        A2.datetime <= '2022-12-24 23:59:59'\n                        AND A2.end_datetime >= '2022-12-24 00:00:00'\n                    )\n            )\n        ) as `subaup` on `subaup`.`ref_id` = `activity`.`id`\n        right join (\n            (\n                SELECT\n                    DISTINCT main_sql.ref_id\n                FROM\n                    uses_permissions as main_sql\n                    INNER JOIN uses_permissions AS P2 ON main_sql.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity as A1 ON (A1.id = main_sql.ref_id)\n                WHERE\n                    main_sql.parentid = 6\n                    AND main_sql.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-24 23:59:59'\n                        AND A1.end_datetime >= '2022-12-24 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql.type = 'activity'\n                            AND main_sql.current_permission != 0\n                            AND main_sql.profileid IN (1200)\n                        )\n                        OR (\n                            main_sql.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'deal'\n                                    AND uses_permissions.ref_id = main_sql.deal_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                        OR (\n                            main_sql.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'customer'\n                                    AND uses_permissions.ref_id = main_sql.customer_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT main_sql_dept.ref_id\n                FROM\n                    global_permissions as main_sql_dept\n                    INNER JOIN uses_permissions AS P2 ON main_sql_dept.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity AS A1 ON (A1.id = main_sql_dept.ref_id)\n                WHERE\n                    main_sql_dept.parentid = 6\n                    AND main_sql_dept.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-24 23:59:59'\n                        AND A1.end_datetime >= '2022-12-24 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql_dept.type = 'activity'\n                            AND main_sql_dept.current_permission != 0\n                            AND main_sql_dept.profileid IN (11980)\n                        )\n                        OR (\n                            main_sql_dept.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'deal'\n                                    AND global_permissions.ref_id = main_sql_dept.deal_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                        OR (\n                            main_sql_dept.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'customer'\n                                    AND global_permissions.ref_id = main_sql_dept.customer_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                    )\n            )\n        ) as `subaccessq` on `subaccessq`.`ref_id` = `activity`.`id`\n    where\n        `activity`.`isactive` = 1\n        and (1 = 1)\n        and `activity`.`parentid` = 6\n    order by\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) DESC,\n        activity.datetime DESC,\n        activity.id DESC\n    limit\n        7 offset 0\n)\nunion\n(\n    select\n        `activity`.`id`,\n        `activity`.`opporid`,\n        `activity`.`category`,\n        `details`.`name`,\n        `details`.`company`,\n        `activity`.`alertpic`,\n        `activity`.`datetime` as `start`,\n        `activity`.`end_datetime` as `end`,\n        `activity`.`notes` as `description`,\n        `status`.`color`,\n        `status`.`id` as `status_id`,\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) as `is_long`\n    from\n        `activity`\n        left join `opportunities` on `opportunities`.`id` = `activity`.`opporid`\n        left join `details` on `details`.`id` = `opportunities`.`customer_id`\n        left join `status` on `status`.`id` = `activity`.`status`\n        right join (\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    uses_permissions AS U1\n                    LEFT JOIN activity as A1 ON (A1.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (1200)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A1.parentid = 6\n                    AND A1.isactive = 1\n                    AND (\n                        A1.datetime <= '2022-12-25 23:59:59'\n                        AND A1.end_datetime >= '2022-12-25 00:00:00'\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT U1.ref_id\n                FROM\n                    global_permissions AS U1\n                    LEFT JOIN activity AS A2 ON (A2.id = U1.ref_id)\n                    INNER JOIN uses_permissions AS P2 ON U1.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                WHERE\n                    U1.profileid IN (11980)\n                    AND U1.parentid = 6\n                    AND U1.type = 'activity'\n                    AND U1.current_permission = 2\n                    AND A2.parentid = 6\n                    AND A2.isactive = 1\n                    AND (\n                        A2.datetime <= '2022-12-25 23:59:59'\n                        AND A2.end_datetime >= '2022-12-25 00:00:00'\n                    )\n            )\n        ) as `subaup` on `subaup`.`ref_id` = `activity`.`id`\n        right join (\n            (\n                SELECT\n                    DISTINCT main_sql.ref_id\n                FROM\n                    uses_permissions as main_sql\n                    INNER JOIN uses_permissions AS P2 ON main_sql.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity as A1 ON (A1.id = main_sql.ref_id)\n                WHERE\n                    main_sql.parentid = 6\n                    AND main_sql.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-25 23:59:59'\n                        AND A1.end_datetime >= '2022-12-25 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql.type = 'activity'\n                            AND main_sql.current_permission != 0\n                            AND main_sql.profileid IN (1200)\n                        )\n                        OR (\n                            main_sql.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'deal'\n                                    AND uses_permissions.ref_id = main_sql.deal_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                        OR (\n                            main_sql.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    uses_permissions\n                                WHERE\n                                    uses_permissions.type = 'customer'\n                                    AND uses_permissions.ref_id = main_sql.customer_id\n                                    AND uses_permissions.child_permission != 0\n                                    AND uses_permissions.profileid IN (1200)\n                            )\n                        )\n                    )\n            )\n            UNION\n            (\n                SELECT\n                    DISTINCT main_sql_dept.ref_id\n                FROM\n                    global_permissions as main_sql_dept\n                    INNER JOIN uses_permissions AS P2 ON main_sql_dept.ref_id = P2.ref_id\n                    AND P2.parentid = 6\n                    AND P2.type = 'activity'\n                    AND P2.current_permission = 2\n                    AND P2.profileid = 1200\n                    LEFT JOIN activity AS A1 ON (A1.id = main_sql_dept.ref_id)\n                WHERE\n                    main_sql_dept.parentid = 6\n                    AND main_sql_dept.type = 'activity'\n                    AND A1.isactive = 1\n                    AND A1.parentid = 6\n                    AND (\n                        A1.datetime <= '2022-12-25 23:59:59'\n                        AND A1.end_datetime >= '2022-12-25 00:00:00'\n                    )\n                    AND (\n                        (\n                            main_sql_dept.type = 'activity'\n                            AND main_sql_dept.current_permission != 0\n                            AND main_sql_dept.profileid IN (11980)\n                        )\n                        OR (\n                            main_sql_dept.deal_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'deal'\n                                    AND global_permissions.ref_id = main_sql_dept.deal_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                        OR (\n                            main_sql_dept.customer_id IN (\n                                SELECT\n                                    ref_id\n                                FROM\n                                    global_permissions\n                                WHERE\n                                    global_permissions.type = 'customer'\n                                    AND global_permissions.ref_id = main_sql_dept.customer_id\n                                    AND global_permissions.child_permission != 0\n                                    AND global_permissions.profileid IN (11980)\n                            )\n                        )\n                    )\n            )\n        ) as `subaccessq` on `subaccessq`.`ref_id` = `activity`.`id`\n    where\n        `activity`.`isactive` = 1\n        and (1 = 1)\n        and `activity`.`parentid` = 6\n    order by\n        IF(\n            ABS(\n                TIMESTAMPDIFF(\n                    DAY,\n                    `activity`.`datetime`,\n                    `activity`.`end_datetime`\n                )\n            ) > 0,\n            1,\n            0\n        ) DESC,\n        activity.datetime DESC,\n        activity.id DESC\n    limit\n        7 offset 0\n)",
    "table_meta": {
        "staging.activity": "CREATE TABLE `activity` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `opporid_1` varchar(65533) NULL,\n  `profileid` varchar(65533) NULL ,\n  `notes` varchar(65533) NULL COMMENT \"\",\n  `datetime` datetime NULL COMMENT \"\",\n  `category_1` varchar(65533) NULL,\n  `attachment` varchar(65533) NULL COMMENT \"\",\n  `attachment_backup` varchar(65533) NULL COMMENT \"\",\n  `status_1` varchar(65533) NOT NULL DEFAULT \"6\" COMMENT \"status.id\",\n  `address` varchar(65533) NULL COMMENT \"crm_customer_address.id\",\n  `pic` varchar(65533) NULL COMMENT \"ASSIGNED EDIT USER\",\n  `pic_view` varchar(65533) NULL,\n  `pic_edit` varchar(65533) NULL,\n  `pic_chosen` varchar(65533) NULL,\n  `pic_count` varchar(65533) NULL,\n  `alertpic` varchar(65533) NULL,\n  `completed_by` varchar(65533) NULL COMMENT \"\",\n  `completed_date` datetime NULL COMMENT \"\",\n  `isactive` int(11) NOT NULL DEFAULT \"1\" COMMENT \"\",\n  `ishidden` int(11) NOT NULL DEFAULT \"0\" COMMENT \"\",\n  `update_log` varchar(65533) NULL COMMENT \"no more use\",\n  `refid` varchar(65533) NULL COMMENT \"unique seq no\",\n  `created_date` datetime NULL COMMENT \"\",\n  `lastupdated` datetime NULL COMMENT \"\",\n  `seq_no` varchar(65533) NULL COMMENT \"\",\n  `referenceid` varchar(65533) NULL COMMENT \"\",\n  `assign_child` varchar(65533) NULL COMMENT \"\",\n  `end_datetime` datetime NULL COMMENT \"\",\n  `status` bigint(20) NULL COMMENT \"\",\n  `category` bigint(20) NULL COMMENT \"\",\n  `opporid` bigint(20) NULL COMMENT \"\",\n  `datediff_indicator` int(11) NOT NULL DEFAULT \"0\" COMMENT \"\",\n  `status_modification_date` datetime NULL COMMENT \"\",\n  `last_comment_datetime` datetime NULL COMMENT \"\",\n  `last_alert_datetime` datetime NULL COMMENT \"\",\n  `customer_id` bigint(20) NULL COMMENT \"\",\n  `repeat_refid` bigint(20) NULL COMMENT \"\",\n  `source_id` int(11) NULL COMMENT \"\",\n  `source_type` varchar(65533) NULL COMMENT \"\",\n  `unique_comment_categories` varchar(65533) NULL COMMENT \"\",\n  `unique_comment_categories_bk` varchar(65533) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 6 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
        "staging.details": "CREATE TABLE `details` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `contact_id` varchar(65533) NULL COMMENT \"\",\n  `contact_sub_id` varchar(65533) NULL COMMENT \"\",\n  `agent_id` int(11) NULL COMMENT \"accounts.id\",\n  `phone` varchar(65533) NULL COMMENT \"\",\n  `phone_type` varchar(65533) NULL COMMENT \"\",\n  `name` varchar(65533) NULL COMMENT \"\",\n  `company` varchar(65533) NULL COMMENT \"\",\n  `email` varchar(65533) NULL COMMENT \"\",\n  `address` varchar(65533) NULL COMMENT \"\",\n  `reference_code` varchar(65533) NULL COMMENT \"\",\n  `device_name` varchar(65533) NULL COMMENT \"\",\n  `sms_campaign` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `shared_to` varchar(65533) NULL COMMENT \"USED AS A COUNTER TO DETERMINE IF CHECKBOX SHOULD BE GREY, GETS ITS VALUE FROM DEAL AND ACTIVITY\",\n  `full_shared_to` varchar(65533) NOT NULL COMMENT \"ASSIGNED EDIT USER\",\n  `shared_to_view` varchar(65533) NULL COMMENT \"ASSIGNED VIEW USER\",\n  `shared_to_chosen` varchar(65533) NULL COMMENT \"NOT USED\",\n  `isactive` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `isactivenew` int(11) NOT NULL DEFAULT \"1\" COMMENT \"\",\n  `phonelist` varchar(65533) NULL COMMENT \"no more use\",\n  `created_date` datetime NULL COMMENT \"\",\n  `lastupdated` datetime NULL COMMENT \"\",\n  `add_data` varchar(65533) NULL COMMENT \"\",\n  `emaillist` varchar(65533) NULL COMMENT \"no more use\",\n  `reference_list` varchar(65533) NULL COMMENT \"crm_reference.id as json format\",\n  `customer_deal_amount` double NOT NULL DEFAULT \"0.00\" COMMENT \"total amt of deal\",\n  `customer_deal_category_list` varchar(65533) NULL COMMENT \"deal category list as string\",\n  `customer_category` varchar(65533) NULL COMMENT \"category list as json format\",\n  `customer_deal_assign` varchar(65533) NULL COMMENT \"no more use\",\n  `customer_deal_view` varchar(65533) NULL COMMENT \"no more use\",\n  `photo` varchar(65533) NULL COMMENT \"\",\n  `seq_no` varchar(65533) NULL COMMENT \"\",\n  `assign_child` varchar(65533) NULL COMMENT \"Add grey and assign to all child\",\n  `customer_category_id` bigint(20) NULL COMMENT \"\",\n  `customer_status_id` bigint(20) NULL COMMENT \"\",\n  `default_deal_id` bigint(20) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 2 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
        "staging.opportunities": "CREATE TABLE `opportunities` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `profileid` int(11) NOT NULL COMMENT \"\",\n  `customer_id2` varchar(65533) NOT NULL COMMENT \"\",\n  `title` varchar(65533) NOT NULL COMMENT \"\",\n  `description` varchar(65533) NULL COMMENT \"\",\n  `deal_date` varchar(65533) NOT NULL COMMENT \"\",\n  `amount` decimal64(15, 2) NULL DEFAULT \"0.00\" COMMENT \"\",\n  `status` int(11) NOT NULL DEFAULT \"0\" COMMENT \"status.id\",\n  `category` int(11) NOT NULL COMMENT \"\",\n  `category_list` varchar(65533) NULL COMMENT \"crm_category.id as json format\",\n  `date` varchar(65533) NOT NULL COMMENT \"\",\n  `modifieddate` datetime NOT NULL COMMENT \"\",\n  `isactive` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `refid` varchar(65533) NULL COMMENT \"unique running no\",\n  `assigned_to` varchar(65533) NULL COMMENT \"green assign\",\n  `assigned_to_view` varchar(65533) NULL COMMENT \"green view\",\n  `assigned_to_edit` varchar(65533) NULL COMMENT \"NOT USED ANYMORE\",\n  `assigned_to_chosen` varchar(65533) NULL COMMENT \"NOT USED ANYMORE\",\n  `assigned_to_count` varchar(65533) NULL ,\n  `alert_assigned` varchar(65533) NULL COMMENT \"deal alert for user\",\n  `referenceid` varchar(65533) NULL COMMENT \"link to crm_reference\",\n  `seq_no` varchar(65533) NULL COMMENT \"\",\n  `assign_child` varchar(65533) NULL COMMENT \"\",\n  `deal_category_id` int(11) NULL COMMENT \"\",\n  `customer_id` bigint(20) NULL COMMENT \"\",\n  `deal_end_datetime` datetime NULL COMMENT \"\",\n  `deal_start_datetime` datetime NULL COMMENT \"\",\n  `deal_completed_date` datetime NULL COMMENT \"\",\n  `deal_status_change_date` datetime NULL COMMENT \"\",\n  `deal_completed_by` bigint(20) NULL COMMENT \"\",\n  `def_ind` bigint(20) NULL DEFAULT \"0\" COMMENT \"\",\n  `collection_balance` decimal64(15, 2) NULL DEFAULT \"0.00\" COMMENT \"\",\n  `old_status` varchar(65533) NULL COMMENT \"\",\n  `last_alert_datetime` datetime NULL COMMENT \"\",\n  `last_comment_datetime` datetime NULL COMMENT \"\",\n  `collection` decimal64(15, 2) NULL DEFAULT \"0.00\" COMMENT \"\",\n  `unique_comment_categories` varchar(65533) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
        "staging.status": "CREATE TABLE `status` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `name` varchar(65533) NOT NULL COMMENT \"\",\n  `type` varchar(65533) NOT NULL COMMENT \"\",\n  `isactive` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `ishide` varchar(65533) NULL COMMENT \"\",\n  `color` varchar(65533) NULL COMMENT \"\",\n  `sort` int(11) NULL COMMENT \"\",\n  `user_edit` int(11) NOT NULL DEFAULT \"1\" COMMENT \"\",\n  `customer_edit` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `status_change` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `df_creation` int(11) NULL DEFAULT \"2\" COMMENT \"\",\n  `type_original` varchar(65533) NULL COMMENT \"\",\n  `send_type` varchar(65533) NULL DEFAULT \"PDF\u0026EMAIL\" COMMENT \"\",\n  `company_parentid` bigint(20) NULL COMMENT \"\",\n  `code` varchar(65533) NULL COMMENT \"\",\n  `send_pf_email` varchar(65533) NOT NULL DEFAULT \"Enable\" COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
        "staging.global_permissions": "CREATE TABLE `global_permissions` (\n  `id` bigint(20) NOT NULL COMMENT \"\",\n  `parentid` bigint(20) NULL COMMENT \"\",\n  `profileid` bigint(20) NULL COMMENT \"category.id type user\",\n  `type` varchar(65533) NULL,\n  `current_permission` bigint(20) NULL COMMENT \"\",\n  `child_permission` bigint(20) NULL COMMENT \"\",\n  `no_of_child_view` bigint(20) NULL COMMENT \"\",\n  `ref_id` bigint(20) NULL COMMENT \"customer.id, oppo.id, activity.id\",\n  `status` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `created_datetime` datetime NULL COMMENT \"\",\n  `modified_datetime` datetime NULL COMMENT \"\",\n  `created_by` bigint(20) NULL COMMENT \"\",\n  `modified_by` bigint(20) NULL COMMENT \"\",\n  `profileid_bk` bigint(20) NULL COMMENT \"\",\n  `profileid_backup` bigint(20) NULL COMMENT \"\",\n  `start_datetime` datetime NULL COMMENT \"\",\n  `end_datetime` datetime NULL COMMENT \"\",\n  `deal_id` bigint(20) NULL COMMENT \"\",\n  `customer_id` bigint(20) NULL COMMENT \"\",\n  `type_original` varchar(65533) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 6 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
        "staging.uses_permissions": "CREATE TABLE `uses_permissions` (\n  `id` bigint(20) NOT NULL COMMENT \"\",\n  `parentid` bigint(20) NULL COMMENT \"\",\n  `profileid` bigint(20) NULL COMMENT \"\",\n  `type` varchar(65533) NULL,\n  `current_permission` bigint(20) NULL COMMENT \"\",\n  `child_permission` largeint(40) NULL COMMENT \"\",\n  `no_of_child_view` bigint(20) NULL COMMENT \"\",\n  `ref_id` bigint(20) NULL COMMENT \"customer.id, oppo.id, activity.id\",\n  `status` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `created_datetime` datetime NULL COMMENT \"\",\n  `modified_datetime` datetime NULL COMMENT \"\",\n  `created_by` bigint(20) NULL COMMENT \"\",\n  `modified_by` bigint(20) NULL COMMENT \"\",\n  `mig_ind` int(11) NULL DEFAULT \"0\" COMMENT \"\",\n  `start_datetime` datetime NULL COMMENT \"\",\n  `end_datetime` datetime NULL COMMENT \"\",\n  `deal_id` bigint(20) NULL COMMENT \"\",\n  `customer_id` bigint(20) NULL COMMENT \"\",\n  `type_original` varchar(65533) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 6 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);"
    },
    "table_row_count": {
        "staging.uses_permissions": {
            "uses_permissions": 400000
        },
        "staging.global_permissions": {
            "global_permissions": 580175
        },
        "staging.details": {
            "details": 50000
        },
        "staging.status": {
            "status": 20000
        },
        "staging.activity": {
            "activity": 130000
        },
        "staging.opportunities": {
            "opportunities": 30000
        }
    },
    "session_variables": "{\"enable_show_all_variables\":false,\"cbo_cte_reuse\":true,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate\":1.2,\"transmission_encode_level\":7,\"character_set_results\":\"utf8\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":true,\"enable_resource_group_v2\":true,\"new_planner_optimize_timeout\":3000,\"enable_realtime_mv\":false,\"enable_adaptive_sink_dop\":true,\"force_schedule_local\":false,\"enable_profile\":false,\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":0,\"sql_safe_updates\":0,\"enable_local_shuffle_agg\":true,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"nested_mv_rewrite_max_level\":3,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"enable_populate_block_cache\":true,\"profile_limit_fold\":true,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"cbo_max_reorder_node_use_dp\":10,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"forward_to_leader\":false,\"query_cache_agg_cardinality_limit\":5000000,\"query_timeout\":300,\"enable_pipeline_query_statistic\":true,\"cbo_max_reorder_node\":50,\"cboPushDownAggregateMode_v1\":-1,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":true,\"interpolate_passthrough\":true,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"broadcast_right_table_scale_factor\":10,\"disable_streaming_preaggregations\":false,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"enable_scan_block_cache\":false,\"div_precision_increment\":4,\"auto_increment_increment\":1,\"sql_mode_v2\":32,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":true,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"cbo_cte_max_limit\":10,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"hive_partition_stats_sample_size\":3000,\"enable_optimizer_trace_log\":false,\"enable_mv_planner\":false,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"profile_timeout\":2,\"pipeline_dop\":0,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"query_cache_hot_partition_num\":3,\"query_cache_type\":0,\"disable_colocate_join\":false,\"query_cache_entry_max_rows\":409600,\"max_pushdown_conditions_per_column\":-1,\"enable_materialized_view_union_rewrite\":true,\"enable_exchange_pass_through\":true,\"query_cache_entry_max_bytes\":4194304,\"innodb_read_only\":true,\"enable_exchange_perf\":false,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"enable_query_cache\":false,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"NO_COMPRESSION\",\"interactive_timeout\":3600,\"max_allowed_packet\":1048576,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Etc/UTC\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"enable_query_debug_trace\":false,\"allow_default_partition\":false}",
    "column_statistics": {
        "staging.uses_permissions": {
            "ref_id": "[-14.0, 128765.0, 0.0, 8.0, 117517.0] ESTIMATE",
            "child_permission": "[0.0, 2.0, 0.0, 16.0, 3.0] ESTIMATE",
            "current_permission": "[0.0, 2.0, 0.0, 8.0, 3.0] ESTIMATE",
            "profileid": "[0.0, 24606.0, 0.0, 8.0, 1285.0] ESTIMATE",
            "type": "[-Infinity, Infinity, 0.0, 7.441686203251129, 11.0] ESTIMATE",
            "deal_id": "[0.0, 113772.0, 0.08839927522933408, 8.0, 4111.0] ESTIMATE",
            "customer_id": "[0.0, 55873.0, 0.18290120217844763, 8.0, 4314.0] ESTIMATE",
            "parentid": "[6.0, 2687.0, 0.0, 8.0, 245.0] ESTIMATE"
        },
        "staging.global_permissions": {
            "ref_id": "[-14.0, 128765.0, 0.0, 8.0, 115588.0] ESTIMATE",
            "child_permission": "[0.0, 2.0, 0.0, 8.0, 3.0] ESTIMATE",
            "current_permission": "[0.0, 2.0, 0.0, 8.0, 3.0] ESTIMATE",
            "profileid": "[0.0, 47151.0, 0.0, 8.0, 1090.0] ESTIMATE",
            "type": "[-Infinity, Infinity, 0.0, 7.43841205247341, 10.0] ESTIMATE",
            "customer_id": "[0.0, 55873.0, 0.4202246301807496, 8.0, 3636.0] ESTIMATE",
            "deal_id": "[0.0, 113772.0, 0.17565138795460747, 8.0, 3493.0] ESTIMATE",
            "parentid": "[6.0, 2687.0, 0.0, 8.0, 238.0] ESTIMATE"
        },
        "staging.details": {
            "name": "[-Infinity, Infinity, 0.0, 14.833814217385411, 26081.0] ESTIMATE",
            "company": "[-Infinity, Infinity, 0.0, 16.05042504986348, 21959.0] ESTIMATE",
            "id": "[1.0, 55873.0, 0.0, 4.0, 52070.0] ESTIMATE"
        },
        "staging.status": {
            "color": "[-Infinity, Infinity, 0.0, 7.0, 695.0] ESTIMATE",
            "id": "[1.0, 22247.0, 0.0, 4.0, 21009.0] ESTIMATE"
        },
        "staging.activity": {
            "datetime": "[0.0, 1.9425852E9, 0.0, 8.0, 32477.0] ESTIMATE",
            "notes": "[-Infinity, Infinity, 2.809164117610338E-4, 27.763936575316812, 16552.0] ESTIMATE",
            "end_datetime": "[0.0, 1.9426104E9, 0.0, 8.0, 33550.0] ESTIMATE",
            "isactive": "[0.0, 1.0, 0.0, 4.0, 2.0] ESTIMATE",
            "alertpic": "[-Infinity, Infinity, 7.803233660028715E-6, 2.221806916786316, 1201.0] ESTIMATE",
            "id": "[3.0, 128765.0, 0.0, 4.0, 127070.0] ESTIMATE",
            "category": "[0.0, 47172.0, 8.583557026031588E-5, 8.0, 2440.0] ESTIMATE",
            "opporid": "[0.0, 113772.0, 0.002169282030073428, 8.0, 13675.0] ESTIMATE",
            "parentid": "[6.0, 2687.0, 0.0, 4.0, 345.0] ESTIMATE",
            "status": "[0.0, 22236.0, 0.0, 8.0, 1543.0] ESTIMATE"
        },
        "staging.opportunities": {
            "id": "[11.0, 25815.0, 0.0, 4.0, 24988.0] ESTIMATE",
            "customer_id": "[0.0, 55873.0, 0.0, 8.0, 11641.0] ESTIMATE"
        }
    },
    "be_number": 3,
    "be_core_stat": {
        "numOfHardwareCoresPerBe": "{\"10003\":4,\"10004\":4,\"10005\":4}",
        "cachedAvgNumOfHardwareCores": 4
    },
    "exception": [],
    "version": "UNKNOWN",
    "commit_version": "db1716d7b"
}